﻿@inject ISysFieldTypeService DbCodeService
@{
    ViewData["Title"] = "字段映射关系 管理";
    var lstProvider = ConvertHelper.ToEnumList(typeof(ProviderType), true);
    var lstCodeType = DbCodeService.GetAll();
}
<div class="wrapper wrapper-content animated fadeInRight">
    <div class="row">
        <div class="col-lg-12">
            <div class="ibox float-e-margins">
                <div class="ibox-content text-center p-md ibox-content-search">
                    <form class="form-horizontal" datatable="tableGrid">
                        <div class="form-group col-md-4">
                            <label for="keyWord" class="col-md-3 control-label text-right">关键字</label>
                            <div class="col-md-9">
                                <input id="keyWord" name="keyWord" class="form-control" placeholder="关键字" />
                            </div>
                        </div>

                        <div>

                            <a class="btn  btn-danger  pull-right btn-rounded btn-outline btn-delete"><i class="fa fa-trash"></i>删  除</a>
                            <label class="pull-right">&nbsp; &nbsp;</label>
                            <a class="btn  btn-primary pull-right btn-rounded btn-outline" asp-action="Edit"><i class="fa fa-plus"></i>新  增</a>
                            <label class="pull-right">&nbsp; &nbsp;</label>
                            <a class="btn btn-primary pull-right btn-rounded btn-search"><i class="fa fa-search"></i>搜  索</a>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
    <div class="row">
        <div class="col-lg-12">
            <div class="ibox float-e-margins">
                <div class="ibox-content text-center p-md">
                    <div class="table-responsive">
                        <table class="table table-striped table-bordered table-hover dataTables" id="tableGrid">
                            <thead>
                                <tr>
                                    <td>
                                        <div class="i-checks">
                                            <label> <input type="checkbox" class="thead checkall" title="全选" /></label>
                                        </div>
                                    </td>
                                    <td> 数据库类型</td>
                                    <td> 字段名称</td>
                                    <td> 系统类型</td>
                                    <td>操作</td>
                                </tr>

                            </thead>

                            <tfoot>

                                <tr>
                                    <td>
                                        <div class="i-checks">
                                            <label> <input type="checkbox" class="tfoot checkall" title="全选" /></label>
                                        </div>
                                    </td>
                                    <td> 数据库类型</td>
                                    <td> 字段名称</td>
                                    <td> 系统类型</td>
                                    <td>操作</td>
                                </tr>
                            </tfoot>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@section scripts{
    <script type="text/javascript">
        var providerType=@Html.Raw(lstProvider.ToJson());
        var SysDbType=@Html.Raw(lstCodeType.ToJson());
	$(document).ready(function(){
		$(".form-horizontal").CustomForm({
                isValidate: false,
                isTable:false
            });
		var table = $(".dataTables").CustomForm({
		isValidate: false,
		isTable: true,
		"order": [[1, "desc"]], //默认排序
		deleteUrl:"@Url.Action("Delete")",
		ajaxUrl: "@Url.Action("ForGrid")",
		"columns": [
            CONSTANT.DATA_TABLES.COLUMN.CHECKBOX("DbFieldRelationTypeId")
             , {
                 "name": "DbProviderId", "data": "DbProviderId", "title": " 数据库类型", "sDefaultContent": "", "type": 'string', "format": '', "bSortable": true, render: function (data, type, row) {

                     var text="SqlServer";
                     $.each(providerType,function(key,value){
                         if(key==row.DbProviderId)
                         {
                             text=value;
                             return false;
                         }
                     });
                     return text;

                 }
             }
			,{"name": "DbTypeName", "data":"DbTypeName", "title": " 字段名称", "sDefaultContent": "", "type": 'string',"format":'', "bSortable":true}
			,{"name": "SysDbType", "data":"SysDbType", "title": " 系统类型", "sDefaultContent": "", "type": 'int',"format":'', "bSortable":true
				,render: function (data, type, row)
				{
				    var text="string";
				    $.each(SysDbType,function(index,item){
                        if (item.SysFieldTypeId == row.SysFieldTypeId)
				        {
				            text=item.DbTypeName;
				            return false;
				        }
				    });
				    return text;

				}
			}
			,CONSTANT.DATA_TABLES.COLUMN.LASTMODIFYDATE
            , CONSTANT.DATA_TABLES.COLUMN.ACTIONBTN("DbFieldRelationTypeId", "@Url.Action("Edit")")
		 ],
		 "fnServerParams": function(data) {
			data.keyWord = $("#keyWord").val();//搜索参数
		}
	});
	});
    </script>
}
